Imports System.Data.SqlClient

Public Class <OwnerU>_<TableU>DataClass

    Friend da As New SqlDataAdapter()

    Public Shared Function SelectAll() As String
        Return "SELECT " _ 
            <Loop>
            & "    <SF[,]>[<FieldC>] = [<Field>] " _
            </Loop>
            & "FROM " _
            & "     [<Owner>].[<Table>] " _
            & ""
    End Function

    Public Function Open() As DataTable
        Dim con As SqlConnection = <Database>DataClass.GetConnection
        Dim dt As DataTable = New DataTable
        da.SelectCommand = New SqlCommand(<OwnerU>_<TableU>DataClass.SelectAll, con)
        da.SelectCommand.CommandType = CommandType.Text
        Dim builder As SqlCommandBuilder = New SqlCommandBuilder(da)
        con.Open()
        da.Fill(dt)
        Return dt
    End Function

    Public Sub Save(ByVal grid As DataGridView)
        Try
            Dim dt = CType(grid.DataSource, DataTable)
            da.Update(dt)
            grid.EndEdit()
        Catch
        End Try
    End Sub

End Class
